CSC 240                                  Data Processing and Database Systems                                Fall 2006        

Project Work Distribution Worksheet

 

 

Initials:                                                                                                                                                    _______    _______   _______

 

 

Please Mark the responsibilities of Each Team Member by placing a check or other mark below:

(if your design does not exactly match, feel free to use “other” spaces and/or replace my terminology

 with yours)

 

DESIGN

 

Provided Leadership for DB Design                                                                                                       _______    _______   _______

Provided Insight for DB Design                                                                                                             _______    _______   _______

Provided Input for DB Design                                                                                                               _______    _______   _______

 

 

 

 

REGULAR NEW DATA INPUT

 

Developed Form for New Game data entry                                                                                           _______    _______   _______

Integrated New Game data entry into application                                                                                 _______    _______   _______

Developed Form for New Game Version data entry                                                                              _______    _______   _______

Integrated New Game Version data entry into application                                                                    _______    _______   _______

Developed Form for New Prices data entry                                                                                           _______    _______   _______

Integrated New Prices data entry into application                                                                                                 _______    _______   _______

 

 

 

 

INITIAL (THEN INFREQUENT) NEW DATA INPUT (Optional – Data input (see below) could be done by knowledgeable administrator without a form)

 

Developed Form for New Publisher data entry                                                                                     _______    _______   _______

Integrated New Publisher data entry into application                                                                            _______    _______   _______

Developed Form for New Region data entry                                                                                         _______    _______   _______

Integrated New Region data entry into application                                                                                _______    _______   _______

Developed Form for New Retailer data entry                                                                                        _______    _______   _______

Integrated New Retailer data entry into application                                                                              _______    _______   _______

Developed Form for New Platform data entry                                                                                      _______    _______   _______

Integrated New Platform data entry into application                                                                             _______    _______   _______

Developed Form for other new data entry  (specify)                                                                            _______    _______   _______

Integrated other new data entry into application                                                                                   _______    _______   _______

 

 

 

UPDATES / ERROR CORRECTION

 

Developed Update Price Info approach                                                                                                 _______    _______   _______

Integrated Update Price Info approach into application                                                                        _______    _______   _______

 

 

 

DAILY OPERATIONS

 

Developed Other Daily Operations (specify)                                                                                        _______    _______   _______

Integrated Other Daily Operations into application                                                                              _______    _______   _______

 

 

 

QUERIES / REPORTS

 

Developed Query 1                                                                                                                                                _______    _______   _______

Developed Report to Give Nice Display of Query 1 Results (Optional)                                             _______    _______   _______

Integrated Query 1  into Application                                                                                                     _______    _______   _______

 

Developed Query 2                                                                                                                                                _______    _______   _______

Parameterized Query 2                                                                                                                           _______    _______   _______

Developed Report to Give Nice Display of Query 2 Results (Optional)                                             _______    _______   _______

Integrated Query 2  into Application                                                                                                     _______    _______   _______

 

Developed Query 3                                                                                                                                                _______    _______   _______

Parameterized Query 3                                                                                                                           _______    _______   _______

Developed Report to Give Nice Display of Query 3 Results (Optional)                                             _______    _______   _______

Integrated Query 3  into Application                                                                                                     _______    _______   _______

 

Developed Query 4                                                                                                                                                _______    _______   _______

Parameterized Query 4                                                                                                                           _______    _______   _______

Developed Report to Give Nice Display of Query 4 Results (Optional)                                             _______    _______   _______

Integrated Query 4  into Application                                                                                                     _______    _______   _______

 

Developed Query 5                                                                                                                                                _______    _______   _______

Parameterized Query 5                                                                                                                           _______    _______   _______

Developed Report to Give Nice Display of Query 5 Results (Optional)                                             _______    _______   _______

Integrated Query 5  into Application                                                                                                     _______    _______   _______

 

Developed Query 6                                                                                                                                                _______    _______   _______

Parameterized Query 6                                                                                                                           _______    _______   _______

Developed Report to Give Nice Display of Query 6 Results (Optional)                                             _______    _______   _______

Integrated Query 6  into Application                                                                                                     _______    _______   _______

 

Developed Query 7                                                                                                                                                _______    _______   _______

Parameterized Query 7                                                                                                                           _______    _______   _______

Developed Report to Give Nice Display of Query 7 Results (Optional)                                             _______    _______   _______

Integrated Query 7  into Application                                                                                                     _______    _______   _______

 

Developed Query 8                                                                                                                                                _______    _______   _______

Parameterized Query 8                                                                                                                           _______    _______   _______

Developed Report to Give Nice Display of Query 8 Results (Optional)                                             _______    _______   _______

Integrated Query 8  into Application                                                                                                     _______    _______   _______

 

Developed Query 9                                                                                                                                                _______    _______   _______

Parameterized Query 9                                                                                                                           _______    _______   _______

Developed Report to Give Nice Display of Query 9 Results (Optional)                                             _______    _______   _______

Integrated Query 9  into Application                                                                                                     _______    _______   _______

 

Developed Query 10                                                                                                                              _______    _______   _______

Parameterized Query 10                                                                                                                         _______    _______   _______

Developed Report to Give Nice Display of Query 10 Results (Optional)                                           _______    _______   _______

Integrated Query 10  into Application                                                                                                   _______    _______   _______

 

Developed Query 11                                                                                                                              _______    _______   _______

Developed Report to Give Nice Display of Query 11 Results (Optional)                                           _______    _______   _______

Integrated Query 11  into Application                                                                                                   _______    _______   _______

 

Developed Query 12                                                                                                                              _______    _______   _______

Developed Report to Give Nice Display of Query 12 Results (Optional)                                           _______    _______   _______

Integrated Query 12  into Application                                                                                                   _______    _______   _______

 

Developed Query 13                                                                                                                              _______    _______   _______

Developed Report to Give Nice Display of Query 13 Results (Optional)                                           _______    _______   _______

Integrated Query 13  into Application                                                                                                   _______    _______   _______

 

Developed Query 14                                                                                                                              _______    _______   _______

Developed Report to Give Nice Display of Query 14 Results (Optional)                                           _______    _______   _______

Integrated Query 14  into Application                                                                                                   _______    _______   _______

 

Developed Query 15                                                                                                                              _______    _______   _______

Developed Report to Give Nice Display of Query 15 Results (Optional)                                           _______    _______   _______

Integrated Query 15  into Application                                                                                                   _______    _______   _______

 

Developed Query 16                                                                                                                              _______    _______   _______

Developed Report to Give Nice Display of Query 16 Results (Optional)                                           _______    _______   _______

Integrated Query 16  into Application                                                                                                   _______    _______   _______

 

Developed Query 17                                                                                                                              _______    _______   _______

Parameterized Query 17                                                                                                                         _______    _______   _______

Developed Report to Give Nice Display of Query 17 Results (Optional)                                           _______    _______   _______

Integrated Query 17  into Application                                                                                                   _______    _______   _______

 

Developed Query 18                                                                                                                              _______    _______   _______

Parameterized Query 18                                                                                                                         _______    _______   _______

Developed Report to Give Nice Display of Query 18 Results (Optional)                                           _______    _______   _______

Integrated Query 18  into Application                                                                                                   _______    _______   _______

 

Developed Query 19                                                                                                                              _______    _______   _______

Developed Report to Give Nice Display of Query 19 Results (Optional)                                           _______    _______   _______

Integrated Query 19  into Application                                                                                                   _______    _______   _______

 

 

OTHER (EXTRA) QUERIES/REPORTS (specify)

 

 

 

 

 

 

 

 

 

 

MENUS (Organization of the Application May Vary)

 

Developed Main Menu                                                                                                                          _______    _______   _______

Integrated Main Menu into Application                                                                                                                _______    _______   _______

 

 

OTHER MENUS (specify)

 

Developed                                                Menu                                                                                     _______    _______   _______

Integrated                                 Menu into Application                                                                          _______    _______   _______

 

 

 

 

 

NAVIGATION

 

Developed AutoExec Macro                                                                                                                  _______    _______   _______

Developed Allow Drop into Access                                                                                                      _______    _______   _______

 

OTHER (specify)                                                                                                                                   _______    _______   _______

 

OTHER (specify)                                                                                                                                   _______    _______   _______

 

 

 

SAMPLE DATA

 

Developed Sample Data for Publishers                                                                                                  _______    _______   _______

Entered Sample Data for Publishers                                                                                                       _______    _______   _______

Developed Sample Data for Retailers                                                                                                     _______    _______   _______

Entered Sample Data for Retailers                                                                                                         _______    _______   _______

Developed Sample Data for Regions                                                                                                      _______    _______   _______

Entered Sample Data for Regions                                                                                                           _______    _______   _______

Developed Sample Data for Platforms                                                                                                  _______    _______   _______

Entered Sample Data for Platforms                                                                                                        _______    _______   _______

Developed Sample Data for Games                                                                                                        _______    _______   _______

Entered Sample Data for Games                                                                                                             _______    _______   _______

Developed Sample Data for Game Versions                                                                                          _______    _______   _______

Entered Sample Data for Game Versions                                                                                               _______    _______   _______

Developed Sample Data for Prices                                                                                                         _______    _______   _______

Entered Sample Data for Prices                                                                                                              _______    _______   _______

Developed Sample Data for Availabilities                                                                                              _______    _______   _______

Entered Sample Data for Availabilities                                                                                                   _______    _______   _______

Developed Sample Data for other (specify …)                                                                                      _______    _______   _______

Entered Sample Data for other (specify …)                                                                                           _______    _______   _______

Developed Sample Data for other (specify …)                                                                                      _______    _______   _______

Entered Sample Data for other (specify …)                                                                                           _______    _______   _______

 

 

 

 

 

 

PROJECT MANAGEMENT ETC

 

Provided Informal Leadership for Project Development                                                                        _______    _______   _______

Provided Informal Project Management for Project Development                                                       _______    _______   _______

Provided system test effort                                                                                                                    _______    _______   _______

 

 

 

 

DOCUMENTATION

 

Documented Functional Dependencies                                                                                                  _______    _______   _______

Documented Entity-Relationships                                                                                                         _______    _______   _______

Documented how to use application                                                                                                      _______    _______   _______

Documented tables, forms, reports, menus, macros, queries, reports via printouts                              _______    _______   _______

 

 

 

 

OTHER

 

(list ...)                                                                                                                                                    _______    _______   _______